object frmImportacao: TfrmImportacao
  Left = 224
  Top = 134
  BorderStyle = bsSingle
  Caption = 'Importar Registros - Form. Caixa'
  ClientHeight = 178
  ClientWidth = 475
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poScreenCenter
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object cxGroupBox2: TcxGroupBox
    Left = 6
    Top = 4
    Caption = 'Importar Registros - Form. Caixa'
    TabOrder = 0
    Height = 127
    Width = 466
    object Label2: TcxLabel
      Left = 11
      Top = 22
      Caption = 'Caminho da Planilha'
      Style.BorderColor = clNone
      Properties.ShadowedColor = clNone
    end
    object pb: TcxProgressBar
      Left = 12
      Top = 86
      TabOrder = 1
      Width = 439
    end
    object lbl1: TcxLabel
      Left = 12
      Top = 72
      Caption = '.'
      Style.BorderColor = clNone
      Properties.ShadowedColor = clNone
    end
    object lbl2: TcxLabel
      Left = 444
      Top = 72
      Caption = '.'
      Style.BorderColor = clNone
      Properties.Alignment.Horz = taRightJustify
      Properties.ShadowedColor = clNone
      AnchorX = 451
    end
    object BtnDir: TButton
      Left = 429
      Top = 38
      Width = 23
      Height = 23
      Cursor = crHandPoint
      Caption = '...'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Tahoma'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 4
      OnClick = BtnDirClick
    end
    object edtCaminho: TcxTextEdit
      Left = 12
      Top = 40
      Enabled = False
      TabOrder = 5
      Width = 416
    end
  end
  object cxButton2: TcxButton
    Left = 88
    Top = 142
    Width = 75
    Height = 25
    Caption = 'Cancelar'
    TabOrder = 1
    OnClick = cxButton2Click
  end
  object cxButton3: TcxButton
    Left = 8
    Top = 142
    Width = 75
    Height = 25
    Caption = 'Importar'
    TabOrder = 2
    OnClick = cxButton3Click
  end
  object FormContas: TADOTable
    Connection = dmPrincipal.ConnectForm
    CursorType = ctStatic
    TableName = '[Plan1$]'
    Left = 256
    Top = 16
    object FormContasAGOPER: TWideStringField
      FieldName = 'AG#/OPER#'
      Size = 255
    end
    object FormContasCONTA: TWideStringField
      FieldName = 'CONTA'
      Size = 255
    end
    object FormContasCLIENTE: TWideStringField
      FieldName = 'CLIENTE'
      Size = 255
    end
    object FormContasNOMEDEFANTASIA: TWideStringField
      FieldName = 'NOME DE FANTASIA'
      Size = 255
    end
    object FormContasCNPJ: TWideStringField
      FieldName = 'CNPJ'
      Size = 255
    end
    object FormContasENDEREO: TWideStringField
      FieldName = 'ENDERE'#199'O'
      Size = 255
    end
    object FormContasTELEFONE: TWideStringField
      FieldName = 'TELEFONE'
      Size = 255
    end
    object FormContasVALORCROT: TBCDField
      FieldName = 'VALOR CROT'
      Precision = 19
    end
    object FormContasVALORGIM: TBCDField
      FieldName = 'VALOR GIM'
      Precision = 19
    end
    object FormContasDATAASSCROTGIM: TDateTimeField
      FieldName = 'DATA ASS# CROT/GIM'
    end
    object FormContasVLRCHQGIM: TWideStringField
      FieldName = 'VLR#/CHQ# GIM'
      Size = 255
    end
    object FormContasVLRDUPLGIM: TWideStringField
      FieldName = 'VLR#/DUPL# GIM'
      Size = 255
    end
    object FormContasCONTACEDENTE: TWideStringField
      FieldName = 'CONTA CEDENTE'
      Size = 255
    end
    object FormContasVALORCONTR041: TBCDField
      FieldName = 'VALOR CONTR# 041'
      Precision = 19
    end
    object FormContasDATAASS041: TDateTimeField
      FieldName = 'DATA ASS# 041'
    end
    object FormContasDATAVENCTO041: TDateTimeField
      FieldName = 'DATA VENCTO 041'
    end
    object FormContasCONCEITO: TWideStringField
      FieldName = 'CONCEITO'
      Size = 255
    end
    object FormContasDATACONCEITO: TDateTimeField
      FieldName = 'DATA CONCEITO'
    end
    object FormContasVALORCHEQUE041: TBCDField
      FieldName = 'VALOR/CHEQUE 041'
      Precision = 19
    end
    object FormContasVENCTOEXCEPCHQ: TDateTimeField
      FieldName = 'VENCTO# EXCEP#/CHQ#'
    end
    object FormContasVALORDUPL041: TBCDField
      FieldName = 'VALOR/DUPL# 041'
      Precision = 19
    end
    object FormContasVENCTOEXCEPDUPL: TWideStringField
      FieldName = 'VENCTO# EXCEP#/DUPL#'
      Size = 255
    end
    object FormContasTIPOTAC: TFloatField
      FieldName = 'TIPO TAC'
    end
    object FormContasRAMODEATIVIDADESICOB: TWideStringField
      FieldName = 'RAMO DE ATIVIDADE - SICOB'
      Size = 255
    end
    object FormContasVALORCONTRATO734: TBCDField
      FieldName = 'VALOR CONTRATO 734'
      Precision = 19
    end
    object FormContasDATAASS734: TDateTimeField
      FieldName = 'DATA ASS# 734'
    end
    object FormContasDATAVCTOAVALSIRIC: TDateTimeField
      FieldName = 'DATA VCTO# AVAL# SIRIC'
    end
    object FormContasEMAIL: TWideStringField
      FieldName = 'E-MAIL'
      Size = 255
    end
    object FormContasCARTEIRA: TWideStringField
      FieldName = 'CARTEIRA'
      Size = 255
    end
    object FormContasEXCEPCTAXACHEQUES: TWideStringField
      FieldName = 'EXCEPC# TAXA CHEQUES'
      Size = 255
    end
    object FormContasEXCEPCTAXADUPLICATAS: TWideStringField
      FieldName = 'EXCEPC# TAXA DUPLICATAS'
      Size = 255
    end
    object FormContasCNAEs: TWideStringField
      FieldName = 'CNAE'#39's'
      Size = 255
    end
    object FormContasFATURFISCAL: TBCDField
      FieldName = 'FATUR# FISCAL'
      Precision = 19
    end
    object FormContasANOFATUR: TFloatField
      FieldName = 'ANO FATUR#'
    end
    object FormContasQTDFUNC: TFloatField
      FieldName = 'QTD# FUNC#'
    end
  end
  object Contas: TADOTable
    Connection = dmPrincipal.ADOConnection
    CursorType = ctStatic
    TableName = 'TB_CONTA'
    Left = 224
    Top = 16
    object ContasCodigo: TAutoIncField
      FieldName = 'Codigo'
      ReadOnly = True
    end
    object ContasConta: TWideStringField
      FieldName = 'Conta'
      Size = 16
    end
    object ContasCliente: TWideStringField
      FieldName = 'Cliente'
      Size = 50
    end
    object ContasCNPJ: TWideStringField
      FieldName = 'CNPJ'
      Size = 18
    end
    object ContasEndereco: TWideStringField
      FieldName = 'Endereco'
      Size = 35
    end
    object ContasBairro: TWideStringField
      FieldName = 'Bairro'
      Size = 25
    end
    object ContasCidade: TWideStringField
      FieldName = 'Cidade'
      Size = 30
    end
    object ContastxtUF: TWideStringField
      FieldName = 'txtUF'
      Size = 2
    end
    object ContasCEP: TWideStringField
      FieldName = 'CEP'
      Size = 8
    end
    object ContasDataAss183: TWideStringField
      FieldName = 'DataAss183'
      Size = 10
    end
    object ContasVlrMaxChq183: TBCDField
      FieldName = 'VlrMaxChq183'
      Precision = 19
    end
    object ContasVlrMaxDupl183: TBCDField
      FieldName = 'VlrMaxDupl183'
      Precision = 19
    end
    object ContasContaCed: TWideStringField
      FieldName = 'ContaCed'
      Size = 16
    end
    object ContasDataAss041: TWideStringField
      FieldName = 'DataAss041'
      Size = 10
    end
    object ContasVlrMaxChq041: TBCDField
      FieldName = 'VlrMaxChq041'
      Precision = 19
    end
    object ContasVlrMaxDupl041: TBCDField
      FieldName = 'VlrMaxDupl041'
      Precision = 19
    end
    object ContasVlrContrato041: TBCDField
      FieldName = 'VlrContrato041'
      Precision = 19
    end
    object ContasVlrContrato183: TBCDField
      FieldName = 'VlrContrato183'
      Precision = 19
    end
    object ContasBandaChq: TWordField
      FieldName = 'BandaChq'
    end
    object ContasDtExcepChq: TWideStringField
      FieldName = 'DtExcepChq'
      Size = 10
    end
    object ContasBandaDup: TWordField
      FieldName = 'BandaDup'
    end
    object ContasDtExcepDup: TWideStringField
      FieldName = 'DtExcepDup'
      Size = 10
    end
    object ContasTelefone: TWideStringField
      FieldName = 'Telefone'
      Size = 14
    end
    object ContasVlrContrato197: TBCDField
      FieldName = 'VlrContrato197'
      Precision = 19
    end
    object ContasDataConceito041: TWideStringField
      FieldName = 'DataConceito041'
      Size = 10
    end
    object ContasConceito041: TWideStringField
      FieldName = 'Conceito041'
      Size = 2
    end
    object ContasVctoSIRIC: TDateTimeField
      FieldName = 'VctoSIRIC'
    end
    object ContasEmail: TWideStringField
      FieldName = 'Email'
      Size = 50
    end
    object ContasEmail2: TWideStringField
      FieldName = 'Email2'
      Size = 150
    end
    object ContasObservacoes: TMemoField
      FieldName = 'Observacoes'
      BlobType = ftMemo
    end
    object ContasTxDifChq: TFloatField
      FieldName = 'TxDifChq'
    end
    object ContasTxDifDup: TFloatField
      FieldName = 'TxDifDup'
    end
    object ContasVlrSaldo041: TBCDField
      FieldName = 'VlrSaldo041'
      Precision = 19
    end
    object ContasDtSaldo041: TDateTimeField
      FieldName = 'DtSaldo041'
    end
    object ContasTAC041: TWideStringField
      FieldName = 'TAC041'
      Size = 1
    end
    object ContasVlrContrato734: TBCDField
      FieldName = 'VlrContrato734'
      Precision = 19
    end
    object ContasDataAss734: TDateTimeField
      FieldName = 'DataAss734'
    end
    object ContasContextPadrao: TMemoField
      FieldName = 'ContextPadrao'
      BlobType = ftMemo
    end
    object ContasCod_Contador: TFloatField
      FieldName = 'Cod_Contador'
    end
    object ContasContaCedGIM: TWideStringField
      FieldName = 'ContaCedGIM'
      Size = 16
    end
    object ContasDataConceito183: TWideStringField
      FieldName = 'DataConceito183'
      Size = 10
    end
    object ContasConceito183: TWideStringField
      FieldName = 'Conceito183'
      Size = 2
    end
    object ContasEnviaEmail041: TWideStringField
      FieldName = 'EnviaEmail041'
      Size = 1
    end
    object ContasNum_Cedula183: TIntegerField
      FieldName = 'Num_Cedula183'
    end
    object ContasNum_Cedula197: TIntegerField
      FieldName = 'Num_Cedula197'
    end
    object ContasCodSICOB: TWideStringField
      FieldName = 'CodSICOB'
      Size = 8
    end
    object ContasVLRMAXDUPL_ESCR041: TBCDField
      FieldName = 'VLRMAXDUPL_ESCR041'
      Precision = 19
    end
    object ContasCarteira: TIntegerField
      FieldName = 'Carteira'
    end
    object ContasTelefone2: TWideStringField
      FieldName = 'Telefone2'
      Size = 14
    end
    object ContasContato: TWideStringField
      FieldName = 'Contato'
      Size = 30
    end
    object ContasDataSIRIC734: TDateTimeField
      FieldName = 'DataSIRIC734'
    end
    object ContasDataAss194: TDateTimeField
      FieldName = 'DataAss194'
    end
    object ContasContaCaucao194: TWideStringField
      FieldName = 'ContaCaucao194'
      Size = 16
    end
    object ContasContaCedente194: TWideStringField
      FieldName = 'ContaCedente194'
      Size = 16
    end
    object ContasVlrMaxChq194: TBCDField
      FieldName = 'VlrMaxChq194'
      Precision = 19
    end
    object ContasVlrMaxDup194: TBCDField
      FieldName = 'VlrMaxDup194'
      Precision = 19
    end
    object ContasNumEnde: TWideStringField
      FieldName = 'NumEnde'
      Size = 10
    end
    object ContasComplEnde: TWideStringField
      FieldName = 'ComplEnde'
      Size = 25
    end
    object ContasExcepChq_Taxa: TWideStringField
      FieldName = 'ExcepChq_Taxa'
      Size = 10
    end
    object ContasExcepDup_Taxa: TWideStringField
      FieldName = 'ExcepDup_Taxa'
      Size = 10
    end
    object ContasQuantChq: TIntegerField
      FieldName = 'QuantChq'
    end
    object ContasQuantDuplConv: TIntegerField
      FieldName = 'QuantDuplConv'
    end
    object ContasQuantDuplEsc: TIntegerField
      FieldName = 'QuantDuplEsc'
    end
    object ContasTipo: TWideStringField
      FieldName = 'Tipo'
      Size = 1
    end
  end
  object DataSource1: TDataSource
    DataSet = FormContas
    Left = 288
    Top = 8
  end
  object DIR: TOpenDialog
    DefaultExt = 'xls'
    Filter = '*.xls'
    Left = 411
    Top = 11
  end
  object stgImportacao: TcxPropertiesStore
    Components = <
      item
        Component = edtCaminho
        Properties.Strings = (
          'Anchors'
          'AutoSize'
          'BeepOnEnter'
          'Constraints'
          'Cursor'
          'DragCursor'
          'DragKind'
          'DragMode'
          'Enabled'
          'FakeStyleController'
          'Height'
          'HelpContext'
          'HelpKeyword'
          'HelpType'
          'Hint'
          'ImeMode'
          'ImeName'
          'Left'
          'Name'
          'ParentColor'
          'ParentFont'
          'ParentShowHint'
          'PopupMenu'
          'Properties'
          'RepositoryItem'
          'ShowHint'
          'Style'
          'StyleDisabled'
          'StyleFocused'
          'StyleHot'
          'TabOrder'
          'TabStop'
          'Tag'
          'Text'
          'Top'
          'Visible'
          'Width')
      end>
    StorageName = 'stgImportacao'
    Left = 392
    Top = 68
  end
end
